SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE VIEW dbo.vwlAgentesConAportesMinimo
AS
SELECT     dbo.tb_AgentesConAportesMinimo.idAgenteConAporte AS ID, dbo.tb_Agentes.Documento, dbo.tb_Agentes.Nombres, 
                      dbo.tb_AgentesConAportesMinimo.Cuise, dbo.tb_AgentesConAportesMinimo.AportaMinimoJubilatorio, 
                      dbo.tb_AgentesConAportesMinimo.AportaMinimoObraSocial, dbo.tb_AgentesConAportesMinimo.FechaAlta
FROM         dbo.tb_AgentesConAportesMinimo INNER JOIN
                      dbo.tb_Agentes ON dbo.tb_AgentesConAportesMinimo.Agente = dbo.tb_Agentes.idAgente
GO
GRANT SELECT ON  [dbo].[vwlAgentesConAportesMinimo] TO [CentroDeDesignaciones]
GRANT SELECT ON  [dbo].[vwlAgentesConAportesMinimo] TO [PersonalDocente]
GRANT SELECT ON  [dbo].[vwlAgentesConAportesMinimo] TO [SoloVer]
GRANT SELECT ON  [dbo].[vwlAgentesConAportesMinimo] TO [Subsidios]
GRANT SELECT ON  [dbo].[vwlAgentesConAportesMinimo] TO [SubsidiosConsulta]
GO
